Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_APPLY_TABLE_COLUMNS

`ALL_APPLY_TABLE_COLUMNS` displays information about the destination table object columns for the tables accessible to the current user.

Related View

`DBA_APPLY_TABLE_COLUMNS` displays information about the destination table object columns for all tables in the database.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`OBJECT_OWNER` | `VARCHAR2(30)` |  | Owner of the table
`OBJECT_NAME` | `VARCHAR2(30)` |  | Name of the table
`COLUMN_NAME` | `VARCHAR2(4000)` |  | Name of the column
`COMPARE_OLD_ON_DELETE` | `VARCHAR2(3)` |  | Indicates whether to Compare the old value of the column on deletes (`YES`) or not (`NO`)
`COMPARE_OLD_ON_UPDATE` | `VARCHAR2(3)` |  | Indicates whether to Compare the old value of the column on updates (`YES`) or not (`NO`)
`APPLY_DATABASE_LINK` | `VARCHAR2(128)` |  | For remote tables, name of the database link pointing to the remote database

See Also: "DBA_APPLY_TABLE_COLUMNS"